USE [GOSALES_DW]
GO

/****** Object:  Table [dbo].[PRODUCT_DIM]    Script Date: 10/18/2012 19:50:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[PRODUCT_DIM](
	[PRODUCT_NUMBER] [int] NOT NULL,
	[PRODUCT_NAME] [nvarchar](50) NULL,
	[PRODUCT_TYPE_CODE] [int] NOT NULL,
	[PRODUCT_TYPE_ES] [nvarchar](50) NOT NULL,
	[PRODUCT_LINE_CODE] [int] NOT NULL,
	[PRODUCT_LINE_ES] [nvarchar](40) NOT NULL,
	[PRODUCT_COLOR_CODE] [int] NOT NULL,
	[PRODUCT_COLOR_ES] [nvarchar](50) NULL,
	[PRODUCT_BRAND_ES] [nvarchar](50) NULL,
	[PRODUCT_BRAND_CODE] [int] NOT NULL,
	[PRODUCT_SIZE_CODE] [int] NOT NULL,
	[PRODUCT_SIZE_ES] [nvarchar](50) NULL
) ON [PRIMARY]

GO


